package com.deyuanyun.pic.pbf.domain;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;

public class RepairReplacePipeExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public RepairReplacePipeExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        public Criteria andIdIsNull() {
            addCriterion("ID_ is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("ID_ is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(String value) {
            addCriterion("ID_ =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(String value) {
            addCriterion("ID_ <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(String value) {
            addCriterion("ID_ >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(String value) {
            addCriterion("ID_ >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(String value) {
            addCriterion("ID_ <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(String value) {
            addCriterion("ID_ <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLike(String value) {
            addCriterion("ID_ like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotLike(String value) {
            addCriterion("ID_ not like", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<String> values) {
            addCriterion("ID_ in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<String> values) {
            addCriterion("ID_ not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(String value1, String value2) {
            addCriterion("ID_ between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(String value1, String value2) {
            addCriterion("ID_ not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andCreateDateIsNull() {
            addCriterion("CREATE_DATE is null");
            return (Criteria) this;
        }

        public Criteria andCreateDateIsNotNull() {
            addCriterion("CREATE_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andCreateDateEqualTo(Date value) {
            addCriterion("CREATE_DATE =", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotEqualTo(Date value) {
            addCriterion("CREATE_DATE <>", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateGreaterThan(Date value) {
            addCriterion("CREATE_DATE >", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateGreaterThanOrEqualTo(Date value) {
            addCriterion("CREATE_DATE >=", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateLessThan(Date value) {
            addCriterion("CREATE_DATE <", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateLessThanOrEqualTo(Date value) {
            addCriterion("CREATE_DATE <=", value, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateIn(List<Date> values) {
            addCriterion("CREATE_DATE in", values, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotIn(List<Date> values) {
            addCriterion("CREATE_DATE not in", values, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateBetween(Date value1, Date value2) {
            addCriterion("CREATE_DATE between", value1, value2, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateDateNotBetween(Date value1, Date value2) {
            addCriterion("CREATE_DATE not between", value1, value2, "createDate");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNull() {
            addCriterion("CREATE_USER is null");
            return (Criteria) this;
        }

        public Criteria andCreateUserIsNotNull() {
            addCriterion("CREATE_USER is not null");
            return (Criteria) this;
        }

        public Criteria andCreateUserEqualTo(String value) {
            addCriterion("CREATE_USER =", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotEqualTo(String value) {
            addCriterion("CREATE_USER <>", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThan(String value) {
            addCriterion("CREATE_USER >", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserGreaterThanOrEqualTo(String value) {
            addCriterion("CREATE_USER >=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThan(String value) {
            addCriterion("CREATE_USER <", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLessThanOrEqualTo(String value) {
            addCriterion("CREATE_USER <=", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserLike(String value) {
            addCriterion("CREATE_USER like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotLike(String value) {
            addCriterion("CREATE_USER not like", value, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserIn(List<String> values) {
            addCriterion("CREATE_USER in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotIn(List<String> values) {
            addCriterion("CREATE_USER not in", values, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserBetween(String value1, String value2) {
            addCriterion("CREATE_USER between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateUserNotBetween(String value1, String value2) {
            addCriterion("CREATE_USER not between", value1, value2, "createUser");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkIsNull() {
            addCriterion("CREATE_REMARK is null");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkIsNotNull() {
            addCriterion("CREATE_REMARK is not null");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkEqualTo(String value) {
            addCriterion("CREATE_REMARK =", value, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkNotEqualTo(String value) {
            addCriterion("CREATE_REMARK <>", value, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkGreaterThan(String value) {
            addCriterion("CREATE_REMARK >", value, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("CREATE_REMARK >=", value, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkLessThan(String value) {
            addCriterion("CREATE_REMARK <", value, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkLessThanOrEqualTo(String value) {
            addCriterion("CREATE_REMARK <=", value, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkLike(String value) {
            addCriterion("CREATE_REMARK like", value, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkNotLike(String value) {
            addCriterion("CREATE_REMARK not like", value, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkIn(List<String> values) {
            addCriterion("CREATE_REMARK in", values, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkNotIn(List<String> values) {
            addCriterion("CREATE_REMARK not in", values, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkBetween(String value1, String value2) {
            addCriterion("CREATE_REMARK between", value1, value2, "createRemark");
            return (Criteria) this;
        }

        public Criteria andCreateRemarkNotBetween(String value1, String value2) {
            addCriterion("CREATE_REMARK not between", value1, value2, "createRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateDateIsNull() {
            addCriterion("UPDATE_DATE is null");
            return (Criteria) this;
        }

        public Criteria andUpdateDateIsNotNull() {
            addCriterion("UPDATE_DATE is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateDateEqualTo(Date value) {
            addCriterion("UPDATE_DATE =", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateNotEqualTo(Date value) {
            addCriterion("UPDATE_DATE <>", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateGreaterThan(Date value) {
            addCriterion("UPDATE_DATE >", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateGreaterThanOrEqualTo(Date value) {
            addCriterion("UPDATE_DATE >=", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateLessThan(Date value) {
            addCriterion("UPDATE_DATE <", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateLessThanOrEqualTo(Date value) {
            addCriterion("UPDATE_DATE <=", value, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateIn(List<Date> values) {
            addCriterion("UPDATE_DATE in", values, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateNotIn(List<Date> values) {
            addCriterion("UPDATE_DATE not in", values, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateBetween(Date value1, Date value2) {
            addCriterion("UPDATE_DATE between", value1, value2, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateDateNotBetween(Date value1, Date value2) {
            addCriterion("UPDATE_DATE not between", value1, value2, "updateDate");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNull() {
            addCriterion("UPDATE_USER is null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIsNotNull() {
            addCriterion("UPDATE_USER is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateUserEqualTo(String value) {
            addCriterion("UPDATE_USER =", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotEqualTo(String value) {
            addCriterion("UPDATE_USER <>", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThan(String value) {
            addCriterion("UPDATE_USER >", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserGreaterThanOrEqualTo(String value) {
            addCriterion("UPDATE_USER >=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThan(String value) {
            addCriterion("UPDATE_USER <", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLessThanOrEqualTo(String value) {
            addCriterion("UPDATE_USER <=", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserLike(String value) {
            addCriterion("UPDATE_USER like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotLike(String value) {
            addCriterion("UPDATE_USER not like", value, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserIn(List<String> values) {
            addCriterion("UPDATE_USER in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotIn(List<String> values) {
            addCriterion("UPDATE_USER not in", values, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserBetween(String value1, String value2) {
            addCriterion("UPDATE_USER between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateUserNotBetween(String value1, String value2) {
            addCriterion("UPDATE_USER not between", value1, value2, "updateUser");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkIsNull() {
            addCriterion("UPDATE_REMARK is null");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkIsNotNull() {
            addCriterion("UPDATE_REMARK is not null");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkEqualTo(String value) {
            addCriterion("UPDATE_REMARK =", value, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkNotEqualTo(String value) {
            addCriterion("UPDATE_REMARK <>", value, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkGreaterThan(String value) {
            addCriterion("UPDATE_REMARK >", value, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkGreaterThanOrEqualTo(String value) {
            addCriterion("UPDATE_REMARK >=", value, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkLessThan(String value) {
            addCriterion("UPDATE_REMARK <", value, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkLessThanOrEqualTo(String value) {
            addCriterion("UPDATE_REMARK <=", value, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkLike(String value) {
            addCriterion("UPDATE_REMARK like", value, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkNotLike(String value) {
            addCriterion("UPDATE_REMARK not like", value, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkIn(List<String> values) {
            addCriterion("UPDATE_REMARK in", values, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkNotIn(List<String> values) {
            addCriterion("UPDATE_REMARK not in", values, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkBetween(String value1, String value2) {
            addCriterion("UPDATE_REMARK between", value1, value2, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andUpdateRemarkNotBetween(String value1, String value2) {
            addCriterion("UPDATE_REMARK not between", value1, value2, "updateRemark");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNull() {
            addCriterion("DELETED is null");
            return (Criteria) this;
        }

        public Criteria andDeletedIsNotNull() {
            addCriterion("DELETED is not null");
            return (Criteria) this;
        }

        public Criteria andDeletedEqualTo(Short value) {
            addCriterion("DELETED =", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotEqualTo(Short value) {
            addCriterion("DELETED <>", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThan(Short value) {
            addCriterion("DELETED >", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedGreaterThanOrEqualTo(Short value) {
            addCriterion("DELETED >=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThan(Short value) {
            addCriterion("DELETED <", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedLessThanOrEqualTo(Short value) {
            addCriterion("DELETED <=", value, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedIn(List<Short> values) {
            addCriterion("DELETED in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotIn(List<Short> values) {
            addCriterion("DELETED not in", values, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedBetween(Short value1, Short value2) {
            addCriterion("DELETED between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andDeletedNotBetween(Short value1, Short value2) {
            addCriterion("DELETED not between", value1, value2, "deleted");
            return (Criteria) this;
        }

        public Criteria andVsersionIsNull() {
            addCriterion("VSERSION is null");
            return (Criteria) this;
        }

        public Criteria andVsersionIsNotNull() {
            addCriterion("VSERSION is not null");
            return (Criteria) this;
        }

        public Criteria andVsersionEqualTo(Short value) {
            addCriterion("VSERSION =", value, "vsersion");
            return (Criteria) this;
        }

        public Criteria andVsersionNotEqualTo(Short value) {
            addCriterion("VSERSION <>", value, "vsersion");
            return (Criteria) this;
        }

        public Criteria andVsersionGreaterThan(Short value) {
            addCriterion("VSERSION >", value, "vsersion");
            return (Criteria) this;
        }

        public Criteria andVsersionGreaterThanOrEqualTo(Short value) {
            addCriterion("VSERSION >=", value, "vsersion");
            return (Criteria) this;
        }

        public Criteria andVsersionLessThan(Short value) {
            addCriterion("VSERSION <", value, "vsersion");
            return (Criteria) this;
        }

        public Criteria andVsersionLessThanOrEqualTo(Short value) {
            addCriterion("VSERSION <=", value, "vsersion");
            return (Criteria) this;
        }

        public Criteria andVsersionIn(List<Short> values) {
            addCriterion("VSERSION in", values, "vsersion");
            return (Criteria) this;
        }

        public Criteria andVsersionNotIn(List<Short> values) {
            addCriterion("VSERSION not in", values, "vsersion");
            return (Criteria) this;
        }

        public Criteria andVsersionBetween(Short value1, Short value2) {
            addCriterion("VSERSION between", value1, value2, "vsersion");
            return (Criteria) this;
        }

        public Criteria andVsersionNotBetween(Short value1, Short value2) {
            addCriterion("VSERSION not between", value1, value2, "vsersion");
            return (Criteria) this;
        }

        public Criteria andTrenchIdIsNull() {
            addCriterion("TRENCH_ID is null");
            return (Criteria) this;
        }

        public Criteria andTrenchIdIsNotNull() {
            addCriterion("TRENCH_ID is not null");
            return (Criteria) this;
        }

        public Criteria andTrenchIdEqualTo(String value) {
            addCriterion("TRENCH_ID =", value, "trenchId");
            return (Criteria) this;
        }

        public Criteria andTrenchIdNotEqualTo(String value) {
            addCriterion("TRENCH_ID <>", value, "trenchId");
            return (Criteria) this;
        }

        public Criteria andTrenchIdGreaterThan(String value) {
            addCriterion("TRENCH_ID >", value, "trenchId");
            return (Criteria) this;
        }

        public Criteria andTrenchIdGreaterThanOrEqualTo(String value) {
            addCriterion("TRENCH_ID >=", value, "trenchId");
            return (Criteria) this;
        }

        public Criteria andTrenchIdLessThan(String value) {
            addCriterion("TRENCH_ID <", value, "trenchId");
            return (Criteria) this;
        }

        public Criteria andTrenchIdLessThanOrEqualTo(String value) {
            addCriterion("TRENCH_ID <=", value, "trenchId");
            return (Criteria) this;
        }

        public Criteria andTrenchIdLike(String value) {
            addCriterion("TRENCH_ID like", value, "trenchId");
            return (Criteria) this;
        }

        public Criteria andTrenchIdNotLike(String value) {
            addCriterion("TRENCH_ID not like", value, "trenchId");
            return (Criteria) this;
        }

        public Criteria andTrenchIdIn(List<String> values) {
            addCriterion("TRENCH_ID in", values, "trenchId");
            return (Criteria) this;
        }

        public Criteria andTrenchIdNotIn(List<String> values) {
            addCriterion("TRENCH_ID not in", values, "trenchId");
            return (Criteria) this;
        }

        public Criteria andTrenchIdBetween(String value1, String value2) {
            addCriterion("TRENCH_ID between", value1, value2, "trenchId");
            return (Criteria) this;
        }

        public Criteria andTrenchIdNotBetween(String value1, String value2) {
            addCriterion("TRENCH_ID not between", value1, value2, "trenchId");
            return (Criteria) this;
        }

        public Criteria andStartXIsNull() {
            addCriterion("START_X is null");
            return (Criteria) this;
        }

        public Criteria andStartXIsNotNull() {
            addCriterion("START_X is not null");
            return (Criteria) this;
        }

        public Criteria andStartXEqualTo(BigDecimal value) {
            addCriterion("START_X =", value, "startX");
            return (Criteria) this;
        }

        public Criteria andStartXNotEqualTo(BigDecimal value) {
            addCriterion("START_X <>", value, "startX");
            return (Criteria) this;
        }

        public Criteria andStartXGreaterThan(BigDecimal value) {
            addCriterion("START_X >", value, "startX");
            return (Criteria) this;
        }

        public Criteria andStartXGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("START_X >=", value, "startX");
            return (Criteria) this;
        }

        public Criteria andStartXLessThan(BigDecimal value) {
            addCriterion("START_X <", value, "startX");
            return (Criteria) this;
        }

        public Criteria andStartXLessThanOrEqualTo(BigDecimal value) {
            addCriterion("START_X <=", value, "startX");
            return (Criteria) this;
        }

        public Criteria andStartXIn(List<BigDecimal> values) {
            addCriterion("START_X in", values, "startX");
            return (Criteria) this;
        }

        public Criteria andStartXNotIn(List<BigDecimal> values) {
            addCriterion("START_X not in", values, "startX");
            return (Criteria) this;
        }

        public Criteria andStartXBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("START_X between", value1, value2, "startX");
            return (Criteria) this;
        }

        public Criteria andStartXNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("START_X not between", value1, value2, "startX");
            return (Criteria) this;
        }

        public Criteria andStartYIsNull() {
            addCriterion("START_Y is null");
            return (Criteria) this;
        }

        public Criteria andStartYIsNotNull() {
            addCriterion("START_Y is not null");
            return (Criteria) this;
        }

        public Criteria andStartYEqualTo(BigDecimal value) {
            addCriterion("START_Y =", value, "startY");
            return (Criteria) this;
        }

        public Criteria andStartYNotEqualTo(BigDecimal value) {
            addCriterion("START_Y <>", value, "startY");
            return (Criteria) this;
        }

        public Criteria andStartYGreaterThan(BigDecimal value) {
            addCriterion("START_Y >", value, "startY");
            return (Criteria) this;
        }

        public Criteria andStartYGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("START_Y >=", value, "startY");
            return (Criteria) this;
        }

        public Criteria andStartYLessThan(BigDecimal value) {
            addCriterion("START_Y <", value, "startY");
            return (Criteria) this;
        }

        public Criteria andStartYLessThanOrEqualTo(BigDecimal value) {
            addCriterion("START_Y <=", value, "startY");
            return (Criteria) this;
        }

        public Criteria andStartYIn(List<BigDecimal> values) {
            addCriterion("START_Y in", values, "startY");
            return (Criteria) this;
        }

        public Criteria andStartYNotIn(List<BigDecimal> values) {
            addCriterion("START_Y not in", values, "startY");
            return (Criteria) this;
        }

        public Criteria andStartYBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("START_Y between", value1, value2, "startY");
            return (Criteria) this;
        }

        public Criteria andStartYNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("START_Y not between", value1, value2, "startY");
            return (Criteria) this;
        }

        public Criteria andStartZIsNull() {
            addCriterion("START_Z is null");
            return (Criteria) this;
        }

        public Criteria andStartZIsNotNull() {
            addCriterion("START_Z is not null");
            return (Criteria) this;
        }

        public Criteria andStartZEqualTo(BigDecimal value) {
            addCriterion("START_Z =", value, "startZ");
            return (Criteria) this;
        }

        public Criteria andStartZNotEqualTo(BigDecimal value) {
            addCriterion("START_Z <>", value, "startZ");
            return (Criteria) this;
        }

        public Criteria andStartZGreaterThan(BigDecimal value) {
            addCriterion("START_Z >", value, "startZ");
            return (Criteria) this;
        }

        public Criteria andStartZGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("START_Z >=", value, "startZ");
            return (Criteria) this;
        }

        public Criteria andStartZLessThan(BigDecimal value) {
            addCriterion("START_Z <", value, "startZ");
            return (Criteria) this;
        }

        public Criteria andStartZLessThanOrEqualTo(BigDecimal value) {
            addCriterion("START_Z <=", value, "startZ");
            return (Criteria) this;
        }

        public Criteria andStartZIn(List<BigDecimal> values) {
            addCriterion("START_Z in", values, "startZ");
            return (Criteria) this;
        }

        public Criteria andStartZNotIn(List<BigDecimal> values) {
            addCriterion("START_Z not in", values, "startZ");
            return (Criteria) this;
        }

        public Criteria andStartZBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("START_Z between", value1, value2, "startZ");
            return (Criteria) this;
        }

        public Criteria andStartZNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("START_Z not between", value1, value2, "startZ");
            return (Criteria) this;
        }

        public Criteria andStartMileageIsNull() {
            addCriterion("START_MILEAGE is null");
            return (Criteria) this;
        }

        public Criteria andStartMileageIsNotNull() {
            addCriterion("START_MILEAGE is not null");
            return (Criteria) this;
        }

        public Criteria andStartMileageEqualTo(BigDecimal value) {
            addCriterion("START_MILEAGE =", value, "startMileage");
            return (Criteria) this;
        }

        public Criteria andStartMileageNotEqualTo(BigDecimal value) {
            addCriterion("START_MILEAGE <>", value, "startMileage");
            return (Criteria) this;
        }

        public Criteria andStartMileageGreaterThan(BigDecimal value) {
            addCriterion("START_MILEAGE >", value, "startMileage");
            return (Criteria) this;
        }

        public Criteria andStartMileageGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("START_MILEAGE >=", value, "startMileage");
            return (Criteria) this;
        }

        public Criteria andStartMileageLessThan(BigDecimal value) {
            addCriterion("START_MILEAGE <", value, "startMileage");
            return (Criteria) this;
        }

        public Criteria andStartMileageLessThanOrEqualTo(BigDecimal value) {
            addCriterion("START_MILEAGE <=", value, "startMileage");
            return (Criteria) this;
        }

        public Criteria andStartMileageIn(List<BigDecimal> values) {
            addCriterion("START_MILEAGE in", values, "startMileage");
            return (Criteria) this;
        }

        public Criteria andStartMileageNotIn(List<BigDecimal> values) {
            addCriterion("START_MILEAGE not in", values, "startMileage");
            return (Criteria) this;
        }

        public Criteria andStartMileageBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("START_MILEAGE between", value1, value2, "startMileage");
            return (Criteria) this;
        }

        public Criteria andStartMileageNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("START_MILEAGE not between", value1, value2, "startMileage");
            return (Criteria) this;
        }

        public Criteria andEndXIsNull() {
            addCriterion("END_X is null");
            return (Criteria) this;
        }

        public Criteria andEndXIsNotNull() {
            addCriterion("END_X is not null");
            return (Criteria) this;
        }

        public Criteria andEndXEqualTo(BigDecimal value) {
            addCriterion("END_X =", value, "endX");
            return (Criteria) this;
        }

        public Criteria andEndXNotEqualTo(BigDecimal value) {
            addCriterion("END_X <>", value, "endX");
            return (Criteria) this;
        }

        public Criteria andEndXGreaterThan(BigDecimal value) {
            addCriterion("END_X >", value, "endX");
            return (Criteria) this;
        }

        public Criteria andEndXGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("END_X >=", value, "endX");
            return (Criteria) this;
        }

        public Criteria andEndXLessThan(BigDecimal value) {
            addCriterion("END_X <", value, "endX");
            return (Criteria) this;
        }

        public Criteria andEndXLessThanOrEqualTo(BigDecimal value) {
            addCriterion("END_X <=", value, "endX");
            return (Criteria) this;
        }

        public Criteria andEndXIn(List<BigDecimal> values) {
            addCriterion("END_X in", values, "endX");
            return (Criteria) this;
        }

        public Criteria andEndXNotIn(List<BigDecimal> values) {
            addCriterion("END_X not in", values, "endX");
            return (Criteria) this;
        }

        public Criteria andEndXBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("END_X between", value1, value2, "endX");
            return (Criteria) this;
        }

        public Criteria andEndXNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("END_X not between", value1, value2, "endX");
            return (Criteria) this;
        }

        public Criteria andEndYIsNull() {
            addCriterion("END_Y is null");
            return (Criteria) this;
        }

        public Criteria andEndYIsNotNull() {
            addCriterion("END_Y is not null");
            return (Criteria) this;
        }

        public Criteria andEndYEqualTo(BigDecimal value) {
            addCriterion("END_Y =", value, "endY");
            return (Criteria) this;
        }

        public Criteria andEndYNotEqualTo(BigDecimal value) {
            addCriterion("END_Y <>", value, "endY");
            return (Criteria) this;
        }

        public Criteria andEndYGreaterThan(BigDecimal value) {
            addCriterion("END_Y >", value, "endY");
            return (Criteria) this;
        }

        public Criteria andEndYGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("END_Y >=", value, "endY");
            return (Criteria) this;
        }

        public Criteria andEndYLessThan(BigDecimal value) {
            addCriterion("END_Y <", value, "endY");
            return (Criteria) this;
        }

        public Criteria andEndYLessThanOrEqualTo(BigDecimal value) {
            addCriterion("END_Y <=", value, "endY");
            return (Criteria) this;
        }

        public Criteria andEndYIn(List<BigDecimal> values) {
            addCriterion("END_Y in", values, "endY");
            return (Criteria) this;
        }

        public Criteria andEndYNotIn(List<BigDecimal> values) {
            addCriterion("END_Y not in", values, "endY");
            return (Criteria) this;
        }

        public Criteria andEndYBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("END_Y between", value1, value2, "endY");
            return (Criteria) this;
        }

        public Criteria andEndYNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("END_Y not between", value1, value2, "endY");
            return (Criteria) this;
        }

        public Criteria andEndZIsNull() {
            addCriterion("END_Z is null");
            return (Criteria) this;
        }

        public Criteria andEndZIsNotNull() {
            addCriterion("END_Z is not null");
            return (Criteria) this;
        }

        public Criteria andEndZEqualTo(BigDecimal value) {
            addCriterion("END_Z =", value, "endZ");
            return (Criteria) this;
        }

        public Criteria andEndZNotEqualTo(BigDecimal value) {
            addCriterion("END_Z <>", value, "endZ");
            return (Criteria) this;
        }

        public Criteria andEndZGreaterThan(BigDecimal value) {
            addCriterion("END_Z >", value, "endZ");
            return (Criteria) this;
        }

        public Criteria andEndZGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("END_Z >=", value, "endZ");
            return (Criteria) this;
        }

        public Criteria andEndZLessThan(BigDecimal value) {
            addCriterion("END_Z <", value, "endZ");
            return (Criteria) this;
        }

        public Criteria andEndZLessThanOrEqualTo(BigDecimal value) {
            addCriterion("END_Z <=", value, "endZ");
            return (Criteria) this;
        }

        public Criteria andEndZIn(List<BigDecimal> values) {
            addCriterion("END_Z in", values, "endZ");
            return (Criteria) this;
        }

        public Criteria andEndZNotIn(List<BigDecimal> values) {
            addCriterion("END_Z not in", values, "endZ");
            return (Criteria) this;
        }

        public Criteria andEndZBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("END_Z between", value1, value2, "endZ");
            return (Criteria) this;
        }

        public Criteria andEndZNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("END_Z not between", value1, value2, "endZ");
            return (Criteria) this;
        }

        public Criteria andEndMileageIsNull() {
            addCriterion("END_MILEAGE is null");
            return (Criteria) this;
        }

        public Criteria andEndMileageIsNotNull() {
            addCriterion("END_MILEAGE is not null");
            return (Criteria) this;
        }

        public Criteria andEndMileageEqualTo(BigDecimal value) {
            addCriterion("END_MILEAGE =", value, "endMileage");
            return (Criteria) this;
        }

        public Criteria andEndMileageNotEqualTo(BigDecimal value) {
            addCriterion("END_MILEAGE <>", value, "endMileage");
            return (Criteria) this;
        }

        public Criteria andEndMileageGreaterThan(BigDecimal value) {
            addCriterion("END_MILEAGE >", value, "endMileage");
            return (Criteria) this;
        }

        public Criteria andEndMileageGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("END_MILEAGE >=", value, "endMileage");
            return (Criteria) this;
        }

        public Criteria andEndMileageLessThan(BigDecimal value) {
            addCriterion("END_MILEAGE <", value, "endMileage");
            return (Criteria) this;
        }

        public Criteria andEndMileageLessThanOrEqualTo(BigDecimal value) {
            addCriterion("END_MILEAGE <=", value, "endMileage");
            return (Criteria) this;
        }

        public Criteria andEndMileageIn(List<BigDecimal> values) {
            addCriterion("END_MILEAGE in", values, "endMileage");
            return (Criteria) this;
        }

        public Criteria andEndMileageNotIn(List<BigDecimal> values) {
            addCriterion("END_MILEAGE not in", values, "endMileage");
            return (Criteria) this;
        }

        public Criteria andEndMileageBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("END_MILEAGE between", value1, value2, "endMileage");
            return (Criteria) this;
        }

        public Criteria andEndMileageNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("END_MILEAGE not between", value1, value2, "endMileage");
            return (Criteria) this;
        }

        public Criteria andMaterialIsNull() {
            addCriterion("MATERIAL is null");
            return (Criteria) this;
        }

        public Criteria andMaterialIsNotNull() {
            addCriterion("MATERIAL is not null");
            return (Criteria) this;
        }

        public Criteria andMaterialEqualTo(String value) {
            addCriterion("MATERIAL =", value, "material");
            return (Criteria) this;
        }

        public Criteria andMaterialNotEqualTo(String value) {
            addCriterion("MATERIAL <>", value, "material");
            return (Criteria) this;
        }

        public Criteria andMaterialGreaterThan(String value) {
            addCriterion("MATERIAL >", value, "material");
            return (Criteria) this;
        }

        public Criteria andMaterialGreaterThanOrEqualTo(String value) {
            addCriterion("MATERIAL >=", value, "material");
            return (Criteria) this;
        }

        public Criteria andMaterialLessThan(String value) {
            addCriterion("MATERIAL <", value, "material");
            return (Criteria) this;
        }

        public Criteria andMaterialLessThanOrEqualTo(String value) {
            addCriterion("MATERIAL <=", value, "material");
            return (Criteria) this;
        }

        public Criteria andMaterialLike(String value) {
            addCriterion("MATERIAL like", value, "material");
            return (Criteria) this;
        }

        public Criteria andMaterialNotLike(String value) {
            addCriterion("MATERIAL not like", value, "material");
            return (Criteria) this;
        }

        public Criteria andMaterialIn(List<String> values) {
            addCriterion("MATERIAL in", values, "material");
            return (Criteria) this;
        }

        public Criteria andMaterialNotIn(List<String> values) {
            addCriterion("MATERIAL not in", values, "material");
            return (Criteria) this;
        }

        public Criteria andMaterialBetween(String value1, String value2) {
            addCriterion("MATERIAL between", value1, value2, "material");
            return (Criteria) this;
        }

        public Criteria andMaterialNotBetween(String value1, String value2) {
            addCriterion("MATERIAL not between", value1, value2, "material");
            return (Criteria) this;
        }

        public Criteria andManuPipeTypeIsNull() {
            addCriterion("MANU_PIPE_TYPE is null");
            return (Criteria) this;
        }

        public Criteria andManuPipeTypeIsNotNull() {
            addCriterion("MANU_PIPE_TYPE is not null");
            return (Criteria) this;
        }

        public Criteria andManuPipeTypeEqualTo(String value) {
            addCriterion("MANU_PIPE_TYPE =", value, "manuPipeType");
            return (Criteria) this;
        }

        public Criteria andManuPipeTypeNotEqualTo(String value) {
            addCriterion("MANU_PIPE_TYPE <>", value, "manuPipeType");
            return (Criteria) this;
        }

        public Criteria andManuPipeTypeGreaterThan(String value) {
            addCriterion("MANU_PIPE_TYPE >", value, "manuPipeType");
            return (Criteria) this;
        }

        public Criteria andManuPipeTypeGreaterThanOrEqualTo(String value) {
            addCriterion("MANU_PIPE_TYPE >=", value, "manuPipeType");
            return (Criteria) this;
        }

        public Criteria andManuPipeTypeLessThan(String value) {
            addCriterion("MANU_PIPE_TYPE <", value, "manuPipeType");
            return (Criteria) this;
        }

        public Criteria andManuPipeTypeLessThanOrEqualTo(String value) {
            addCriterion("MANU_PIPE_TYPE <=", value, "manuPipeType");
            return (Criteria) this;
        }

        public Criteria andManuPipeTypeLike(String value) {
            addCriterion("MANU_PIPE_TYPE like", value, "manuPipeType");
            return (Criteria) this;
        }

        public Criteria andManuPipeTypeNotLike(String value) {
            addCriterion("MANU_PIPE_TYPE not like", value, "manuPipeType");
            return (Criteria) this;
        }

        public Criteria andManuPipeTypeIn(List<String> values) {
            addCriterion("MANU_PIPE_TYPE in", values, "manuPipeType");
            return (Criteria) this;
        }

        public Criteria andManuPipeTypeNotIn(List<String> values) {
            addCriterion("MANU_PIPE_TYPE not in", values, "manuPipeType");
            return (Criteria) this;
        }

        public Criteria andManuPipeTypeBetween(String value1, String value2) {
            addCriterion("MANU_PIPE_TYPE between", value1, value2, "manuPipeType");
            return (Criteria) this;
        }

        public Criteria andManuPipeTypeNotBetween(String value1, String value2) {
            addCriterion("MANU_PIPE_TYPE not between", value1, value2, "manuPipeType");
            return (Criteria) this;
        }

        public Criteria andDiameterIsNull() {
            addCriterion("DIAMETER is null");
            return (Criteria) this;
        }

        public Criteria andDiameterIsNotNull() {
            addCriterion("DIAMETER is not null");
            return (Criteria) this;
        }

        public Criteria andDiameterEqualTo(String value) {
            addCriterion("DIAMETER =", value, "diameter");
            return (Criteria) this;
        }

        public Criteria andDiameterNotEqualTo(String value) {
            addCriterion("DIAMETER <>", value, "diameter");
            return (Criteria) this;
        }

        public Criteria andDiameterGreaterThan(String value) {
            addCriterion("DIAMETER >", value, "diameter");
            return (Criteria) this;
        }

        public Criteria andDiameterGreaterThanOrEqualTo(String value) {
            addCriterion("DIAMETER >=", value, "diameter");
            return (Criteria) this;
        }

        public Criteria andDiameterLessThan(String value) {
            addCriterion("DIAMETER <", value, "diameter");
            return (Criteria) this;
        }

        public Criteria andDiameterLessThanOrEqualTo(String value) {
            addCriterion("DIAMETER <=", value, "diameter");
            return (Criteria) this;
        }

        public Criteria andDiameterLike(String value) {
            addCriterion("DIAMETER like", value, "diameter");
            return (Criteria) this;
        }

        public Criteria andDiameterNotLike(String value) {
            addCriterion("DIAMETER not like", value, "diameter");
            return (Criteria) this;
        }

        public Criteria andDiameterIn(List<String> values) {
            addCriterion("DIAMETER in", values, "diameter");
            return (Criteria) this;
        }

        public Criteria andDiameterNotIn(List<String> values) {
            addCriterion("DIAMETER not in", values, "diameter");
            return (Criteria) this;
        }

        public Criteria andDiameterBetween(String value1, String value2) {
            addCriterion("DIAMETER between", value1, value2, "diameter");
            return (Criteria) this;
        }

        public Criteria andDiameterNotBetween(String value1, String value2) {
            addCriterion("DIAMETER not between", value1, value2, "diameter");
            return (Criteria) this;
        }

        public Criteria andWallThicknessIsNull() {
            addCriterion("WALL_THICKNESS is null");
            return (Criteria) this;
        }

        public Criteria andWallThicknessIsNotNull() {
            addCriterion("WALL_THICKNESS is not null");
            return (Criteria) this;
        }

        public Criteria andWallThicknessEqualTo(BigDecimal value) {
            addCriterion("WALL_THICKNESS =", value, "wallThickness");
            return (Criteria) this;
        }

        public Criteria andWallThicknessNotEqualTo(BigDecimal value) {
            addCriterion("WALL_THICKNESS <>", value, "wallThickness");
            return (Criteria) this;
        }

        public Criteria andWallThicknessGreaterThan(BigDecimal value) {
            addCriterion("WALL_THICKNESS >", value, "wallThickness");
            return (Criteria) this;
        }

        public Criteria andWallThicknessGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("WALL_THICKNESS >=", value, "wallThickness");
            return (Criteria) this;
        }

        public Criteria andWallThicknessLessThan(BigDecimal value) {
            addCriterion("WALL_THICKNESS <", value, "wallThickness");
            return (Criteria) this;
        }

        public Criteria andWallThicknessLessThanOrEqualTo(BigDecimal value) {
            addCriterion("WALL_THICKNESS <=", value, "wallThickness");
            return (Criteria) this;
        }

        public Criteria andWallThicknessIn(List<BigDecimal> values) {
            addCriterion("WALL_THICKNESS in", values, "wallThickness");
            return (Criteria) this;
        }

        public Criteria andWallThicknessNotIn(List<BigDecimal> values) {
            addCriterion("WALL_THICKNESS not in", values, "wallThickness");
            return (Criteria) this;
        }

        public Criteria andWallThicknessBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("WALL_THICKNESS between", value1, value2, "wallThickness");
            return (Criteria) this;
        }

        public Criteria andWallThicknessNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("WALL_THICKNESS not between", value1, value2, "wallThickness");
            return (Criteria) this;
        }

        public Criteria andLenthIsNull() {
            addCriterion("LENTH is null");
            return (Criteria) this;
        }

        public Criteria andLenthIsNotNull() {
            addCriterion("LENTH is not null");
            return (Criteria) this;
        }

        public Criteria andLenthEqualTo(BigDecimal value) {
            addCriterion("LENTH =", value, "lenth");
            return (Criteria) this;
        }

        public Criteria andLenthNotEqualTo(BigDecimal value) {
            addCriterion("LENTH <>", value, "lenth");
            return (Criteria) this;
        }

        public Criteria andLenthGreaterThan(BigDecimal value) {
            addCriterion("LENTH >", value, "lenth");
            return (Criteria) this;
        }

        public Criteria andLenthGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("LENTH >=", value, "lenth");
            return (Criteria) this;
        }

        public Criteria andLenthLessThan(BigDecimal value) {
            addCriterion("LENTH <", value, "lenth");
            return (Criteria) this;
        }

        public Criteria andLenthLessThanOrEqualTo(BigDecimal value) {
            addCriterion("LENTH <=", value, "lenth");
            return (Criteria) this;
        }

        public Criteria andLenthIn(List<BigDecimal> values) {
            addCriterion("LENTH in", values, "lenth");
            return (Criteria) this;
        }

        public Criteria andLenthNotIn(List<BigDecimal> values) {
            addCriterion("LENTH not in", values, "lenth");
            return (Criteria) this;
        }

        public Criteria andLenthBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("LENTH between", value1, value2, "lenth");
            return (Criteria) this;
        }

        public Criteria andLenthNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("LENTH not between", value1, value2, "lenth");
            return (Criteria) this;
        }

        public Criteria andCoatingMaterialIsNull() {
            addCriterion("COATING_MATERIAL is null");
            return (Criteria) this;
        }

        public Criteria andCoatingMaterialIsNotNull() {
            addCriterion("COATING_MATERIAL is not null");
            return (Criteria) this;
        }

        public Criteria andCoatingMaterialEqualTo(String value) {
            addCriterion("COATING_MATERIAL =", value, "coatingMaterial");
            return (Criteria) this;
        }

        public Criteria andCoatingMaterialNotEqualTo(String value) {
            addCriterion("COATING_MATERIAL <>", value, "coatingMaterial");
            return (Criteria) this;
        }

        public Criteria andCoatingMaterialGreaterThan(String value) {
            addCriterion("COATING_MATERIAL >", value, "coatingMaterial");
            return (Criteria) this;
        }

        public Criteria andCoatingMaterialGreaterThanOrEqualTo(String value) {
            addCriterion("COATING_MATERIAL >=", value, "coatingMaterial");
            return (Criteria) this;
        }

        public Criteria andCoatingMaterialLessThan(String value) {
            addCriterion("COATING_MATERIAL <", value, "coatingMaterial");
            return (Criteria) this;
        }

        public Criteria andCoatingMaterialLessThanOrEqualTo(String value) {
            addCriterion("COATING_MATERIAL <=", value, "coatingMaterial");
            return (Criteria) this;
        }

        public Criteria andCoatingMaterialLike(String value) {
            addCriterion("COATING_MATERIAL like", value, "coatingMaterial");
            return (Criteria) this;
        }

        public Criteria andCoatingMaterialNotLike(String value) {
            addCriterion("COATING_MATERIAL not like", value, "coatingMaterial");
            return (Criteria) this;
        }

        public Criteria andCoatingMaterialIn(List<String> values) {
            addCriterion("COATING_MATERIAL in", values, "coatingMaterial");
            return (Criteria) this;
        }

        public Criteria andCoatingMaterialNotIn(List<String> values) {
            addCriterion("COATING_MATERIAL not in", values, "coatingMaterial");
            return (Criteria) this;
        }

        public Criteria andCoatingMaterialBetween(String value1, String value2) {
            addCriterion("COATING_MATERIAL between", value1, value2, "coatingMaterial");
            return (Criteria) this;
        }

        public Criteria andCoatingMaterialNotBetween(String value1, String value2) {
            addCriterion("COATING_MATERIAL not between", value1, value2, "coatingMaterial");
            return (Criteria) this;
        }

        public Criteria andCoatingGradeIsNull() {
            addCriterion("COATING_GRADE is null");
            return (Criteria) this;
        }

        public Criteria andCoatingGradeIsNotNull() {
            addCriterion("COATING_GRADE is not null");
            return (Criteria) this;
        }

        public Criteria andCoatingGradeEqualTo(String value) {
            addCriterion("COATING_GRADE =", value, "coatingGrade");
            return (Criteria) this;
        }

        public Criteria andCoatingGradeNotEqualTo(String value) {
            addCriterion("COATING_GRADE <>", value, "coatingGrade");
            return (Criteria) this;
        }

        public Criteria andCoatingGradeGreaterThan(String value) {
            addCriterion("COATING_GRADE >", value, "coatingGrade");
            return (Criteria) this;
        }

        public Criteria andCoatingGradeGreaterThanOrEqualTo(String value) {
            addCriterion("COATING_GRADE >=", value, "coatingGrade");
            return (Criteria) this;
        }

        public Criteria andCoatingGradeLessThan(String value) {
            addCriterion("COATING_GRADE <", value, "coatingGrade");
            return (Criteria) this;
        }

        public Criteria andCoatingGradeLessThanOrEqualTo(String value) {
            addCriterion("COATING_GRADE <=", value, "coatingGrade");
            return (Criteria) this;
        }

        public Criteria andCoatingGradeLike(String value) {
            addCriterion("COATING_GRADE like", value, "coatingGrade");
            return (Criteria) this;
        }

        public Criteria andCoatingGradeNotLike(String value) {
            addCriterion("COATING_GRADE not like", value, "coatingGrade");
            return (Criteria) this;
        }

        public Criteria andCoatingGradeIn(List<String> values) {
            addCriterion("COATING_GRADE in", values, "coatingGrade");
            return (Criteria) this;
        }

        public Criteria andCoatingGradeNotIn(List<String> values) {
            addCriterion("COATING_GRADE not in", values, "coatingGrade");
            return (Criteria) this;
        }

        public Criteria andCoatingGradeBetween(String value1, String value2) {
            addCriterion("COATING_GRADE between", value1, value2, "coatingGrade");
            return (Criteria) this;
        }

        public Criteria andCoatingGradeNotBetween(String value1, String value2) {
            addCriterion("COATING_GRADE not between", value1, value2, "coatingGrade");
            return (Criteria) this;
        }

        public Criteria andRecrderIsNull() {
            addCriterion("RECRDER is null");
            return (Criteria) this;
        }

        public Criteria andRecrderIsNotNull() {
            addCriterion("RECRDER is not null");
            return (Criteria) this;
        }

        public Criteria andRecrderEqualTo(String value) {
            addCriterion("RECRDER =", value, "recrder");
            return (Criteria) this;
        }

        public Criteria andRecrderNotEqualTo(String value) {
            addCriterion("RECRDER <>", value, "recrder");
            return (Criteria) this;
        }

        public Criteria andRecrderGreaterThan(String value) {
            addCriterion("RECRDER >", value, "recrder");
            return (Criteria) this;
        }

        public Criteria andRecrderGreaterThanOrEqualTo(String value) {
            addCriterion("RECRDER >=", value, "recrder");
            return (Criteria) this;
        }

        public Criteria andRecrderLessThan(String value) {
            addCriterion("RECRDER <", value, "recrder");
            return (Criteria) this;
        }

        public Criteria andRecrderLessThanOrEqualTo(String value) {
            addCriterion("RECRDER <=", value, "recrder");
            return (Criteria) this;
        }

        public Criteria andRecrderLike(String value) {
            addCriterion("RECRDER like", value, "recrder");
            return (Criteria) this;
        }

        public Criteria andRecrderNotLike(String value) {
            addCriterion("RECRDER not like", value, "recrder");
            return (Criteria) this;
        }

        public Criteria andRecrderIn(List<String> values) {
            addCriterion("RECRDER in", values, "recrder");
            return (Criteria) this;
        }

        public Criteria andRecrderNotIn(List<String> values) {
            addCriterion("RECRDER not in", values, "recrder");
            return (Criteria) this;
        }

        public Criteria andRecrderBetween(String value1, String value2) {
            addCriterion("RECRDER between", value1, value2, "recrder");
            return (Criteria) this;
        }

        public Criteria andRecrderNotBetween(String value1, String value2) {
            addCriterion("RECRDER not between", value1, value2, "recrder");
            return (Criteria) this;
        }

        public Criteria andRecordTimeIsNull() {
            addCriterion("RECORD_TIME is null");
            return (Criteria) this;
        }

        public Criteria andRecordTimeIsNotNull() {
            addCriterion("RECORD_TIME is not null");
            return (Criteria) this;
        }

        public Criteria andRecordTimeEqualTo(Date value) {
            addCriterion("RECORD_TIME =", value, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeNotEqualTo(Date value) {
            addCriterion("RECORD_TIME <>", value, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeGreaterThan(Date value) {
            addCriterion("RECORD_TIME >", value, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeGreaterThanOrEqualTo(Date value) {
            addCriterion("RECORD_TIME >=", value, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeLessThan(Date value) {
            addCriterion("RECORD_TIME <", value, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeLessThanOrEqualTo(Date value) {
            addCriterion("RECORD_TIME <=", value, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeIn(List<Date> values) {
            addCriterion("RECORD_TIME in", values, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeNotIn(List<Date> values) {
            addCriterion("RECORD_TIME not in", values, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeBetween(Date value1, Date value2) {
            addCriterion("RECORD_TIME between", value1, value2, "recordTime");
            return (Criteria) this;
        }

        public Criteria andRecordTimeNotBetween(Date value1, Date value2) {
            addCriterion("RECORD_TIME not between", value1, value2, "recordTime");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}